---- Add column IDDonViHangNam in table BangTinMua ----
alter table [BangTinMua]
	add [IDDonViHangNam] [int] NULL
go

---- alter column ThoiHanDang in table BangTinMua ----
alter table [BangTinMua]
	alter column ThoiHanDang char(19) not null;
go

---- alter column KyHangGiaoHang in table BangTinMua ----
alter table [BangTinMua]
	alter column KyHangGiaoHang nvarchar(20) null;
go

---- alter column TanSuatMuaHang in table BangTinMua ----
alter table [BangTinMua]
	alter column TanSuatMuaHang int null;
go


---- alter column ThoiHanDang in table BangTinBan ----
alter table [BangTinBan]
	alter column ThoiHanDang char(19) not null;
go

---- alter column KyHangGiaoHang in table BangTinBan ----
alter table [BangTinBan]
	alter column KyHanGiaoHang nvarchar(20) null;
go

alter table [SanPham]
	add [LuotContact] [int] NULL
go
